<?php 
include_once('connection/connection.php');
include('header.php');
include('menu.php');
include('config.php');
$frm=$_SESSION['form_id'];
$id1=$_SESSION['id1'];
$dis_name=$_SESSION['dis_name'];
$qr="select * from tbl_dtls_q3_loc where form_id='$frm'";
$res=mysql_query($qr);
$row1=mysql_fetch_array($res);
if(isset($_POST['back']))
{ 
	header('Location: view_q3_6.php');
}	
if(isset($_POST['submit']))
{ 
	echo'<span class="successmssg">You have successfully view this Form. Now you can go on <a href="home.php">home</a> page.</span>';
				exit();
}		
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="css/style_question.css" type="text/css" rel="stylesheet" />
<title>View Q3</title>
</head>
<body>
<div align="center">
<form action="" method="post" enctype="multipart/form-data">
	<table border="0" width="800" id="table1" cellspacing="0" cellpadding="0">
		<tr>
			<td height="30">
			<p align="center">
			<font face="Verdana" style="font-size: 10pt; font-weight: 700" color="#000000">
			Questionnaire No. 3</font></p></td>
		</tr>
		<tr>
			<td height="19">
			<p align="center">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">For Field Survey (Village Level questionnaire)</font></p>            </td>
		</tr>
		<tr>
			<td height="18">
			<p align="center">
			<font style="font-size: 8.5pt" face="Arial" color="#000000">Page 7</font></p></td>
		</tr>
		<tr>
			<td><span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">&nbsp;Form Id = <?php echo $frm?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;District Name = <?php echo $dis_name?></font></span></td>
		</tr>
		<tr><td>&nbsp;</td></tr>
		<tr>
			<td bgcolor="#EEEEEE" height="20"><font color="#000000">&nbsp;
			<span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt">15. Water Supply 
			Infrastructure on Ground&nbsp;</font></span></font></td>
		</tr>
		<tr>
			<td>&nbsp;</td>
		</tr>
		<tr>
			<td>
			<table border="1" width="800" id="table9" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td width="137" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Type</font></td>
					<td height="27" align="center" width="657" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Total Nos.</font></td>
				</tr>
				
				<tr>
					<td><font style="font-size: 8.5pt" face="Verdana" color="#990000">&nbsp;Submersible	pump</font></td>
                    <td><table border="1" width="657" id="table16" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
  					<tr>
    				<td width="15%" bgcolor="#F7E6B7" align="center"></td>
    				<td width="15%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Location</font></td>
    				<td width="15%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Longitude</font></td>
    				<td width="15%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Latitude</font></td>
    				<td width="41%" align="center" height="20" bgcolor="#F7E6B7"><font style="font-size: 8.5pt" face="Verdana" color="#990000"> Status</font></td>
  					</tr>
  			<?php
			$qr2="select * from tbl_dtls_q3_supply_infra_ground where loc_id='$id1' and ground_id LIKE 'Sub%' order by 0+replace(ground_id,'Sub','')";
			$res2=mysql_query($qr2);
			while($row2=mysql_fetch_array($res2))
			{
			?>
  					<tr align="center">
    				<td width="15%"><label id="ground_id"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_id]";?></font></label></td>
    				<td width="15%"><label id="ground_location "><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_location]";?></font></label></td>
    				<td width="15%"><label id="ground_longitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_longitude]";?></font></label></td>
    				<td width="15%"><label id="ground_latitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_latitude]";?></font></label></td>
    				<td width="41%"><label id="ground_status"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_status]";?></font></label></td>
  					</tr>
  			<?php }?>
  					<tr>
    				<td height="2" colspan="8" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"></font></td>
  					</tr>
</table></td></tr>
				
				<tr>
					<td><font style="font-size: 8.5pt" face="Verdana" color="#990000">&nbsp;Mono-Block pump</font></td>
                    <td><table border="1" width="657" id="table16" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
  <tr>
    <td width="15%" bgcolor="#F7E6B7" align="center"></td>
    <td width="15%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Location</font></td>
    <td width="15%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Longitude</font></td>
    <td width="15%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Latitude</font></td>
    <td width="41%" align="center" height="20" bgcolor="#F7E6B7"><font style="font-size: 8.5pt" face="Verdana" color="#990000"> Status</font></td>
  </tr>
  <?php
			$qr2="select * from tbl_dtls_q3_supply_infra_ground where loc_id='$id1' and ground_id LIKE 'Mono%' order by 0+replace(ground_id,'Mono','')";
			$res2=mysql_query($qr2);
			while($row2=mysql_fetch_array($res2))
			{
			?>
  <tr align="center">
    <td width="15%"><label id="ground_id"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_id]";?></font></label></td>
    <td width="15%"><label id="ground_location "><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_location]";?></font></label></td>
    <td width="15%"><label id="ground_longitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_longitude]";?></font></label></td>
    <td width="15%"><label id="ground_latitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_latitude]";?></font></label></td>
    <td width="41%"><label id="ground_status"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_status]";?></label></td>
  </tr>
  <?php } ?>
  <tr>
    <td height="2" colspan="8" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"></font></td>
  </tr>
</table></td></tr>
				
				<tr>
					<td><font style="font-size: 8.5pt" face="Verdana" color="#990000">&nbsp;Centrifugal pump</font></td>
                    <td><table border="1" width="657" id="table16" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
  <tr>
    <td width="15%" bgcolor="#F7E6B7" align="center"></td>
    <td width="15%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Location</font></td>
    <td width="15%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Longitude</font></td>
    <td width="15%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Latitude</font></td>
    <td width="41%" align="center" height="20" bgcolor="#F7E6B7"><font style="font-size: 8.5pt" face="Verdana" color="#990000"> Status</font></td>
  </tr>
  <?php
			$qr2="select * from tbl_dtls_q3_supply_infra_ground where loc_id='$id1' and ground_id LIKE 'Centi%' order by 0+replace(ground_id,'Centi','')";
			$res2=mysql_query($qr2);
			while($row2=mysql_fetch_array($res2))
			{
			?>
  <tr align="center">
    <td width="15%"><label id="ground_id"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_id]";?></font></label></td>
    <td width="15%"><label id="ground_location "><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_location]";?></font></label></td>
    <td width="15%"><label id="ground_longitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_longitude]";?></font></label></td>
    <td width="15%"><label id="ground_latitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_latitude]";?></font></label></td>
    <td width="41%"><label id="ground_status"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_status]";?></label></td>
  </tr>
  <?php  } ?>
  <tr>
    <td height="2" colspan="8" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"></font></td>
  </tr>
</table></td></tr>
				
				<tr>
					<td><font style="font-size: 8.5pt" face="Verdana" color="#990000">&nbsp;Single phase pump</font></td>
                    <td><table border="1" width="657" id="table16" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
  <tr>
    <td width="15%" bgcolor="#F7E6B7" align="center"></td>
    <td width="15%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Location</font></td>
    <td width="15%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Longitude</font></td>
    <td width="15%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Latitude</font></td>
    <td width="41%" align="center" height="20" bgcolor="#F7E6B7"><font style="font-size: 8.5pt" face="Verdana" color="#990000"> Status</font></td>
  </tr>
  <?php
			$qr2="select * from tbl_dtls_q3_supply_infra_ground where loc_id='$id1' and ground_id LIKE 'Sp%' order by 0+replace(ground_id,'Sp','')";
			$res2=mysql_query($qr2);
			while($row2=mysql_fetch_array($res2))
			{
			?>
  <tr align="center">
    <td width="15%"><label id="ground_id"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_id]";?></font></label></td>
    <td width="15%"><label id="ground_location "><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_location]";?></font></label></td>
    <td width="15%"><label id="ground_longitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_longitude]";?></font></label></td>
    <td width="15%"><label id="ground_latitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_latitude]";?></font></label></td>
    <td width="41%"><label id="ground_status"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[ground_status]";?></font></label></td>
  </tr>
  <?php } ?>
  <tr>
    <td height="2" colspan="8" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"></font></td>
  </tr>
</table></td></tr>
			</table></td></tr>
		<tr>
			<td>&nbsp;</td>
		</tr>
		<tr>
			<td bgcolor="#EEEEEE" height="20"><font color="#000000">&nbsp;
			</font><span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">&nbsp;Reservoirs</font></span></td>
		</tr>
		<tr>
			<td height="130">
			<table border="1" width="800" id="table10" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td width="33%" align="center" bgcolor="#F7E6B7">
						<font style="font-size: 8.5pt" face="Verdana" color="#990000">
						Type</font></td>
					<td height="27" align="center" width="46%" bgcolor="#F7E6B7">
						<font face="Verdana" style="font-size: 8.5pt" color="#990000">
						Total Nos.</font></td>
					<td height="27" align="center" width="21%" bgcolor="#F7E6B7">
						<font style="font-size: 8.5pt" face="Verdana" color="#990000">
						In SC/ ST bastis (Nos.)</font></td>
				</tr>
				<tr>
					<td width="33%" height="22">
						<font style="font-size: 8.5pt" face="Verdana" color="#990000">&nbsp;Clear 
						Water Reservoir(CWR)- &nbsp;Underground</font></td>
				  <td width="46%" align="center"><label id="cwr_no"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row1[cwr_no]";?></font></label></td>
				  <td width="21%" align="center"><label id="sc_st_cwr"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row1[sc_st_cwr]";?></font></label></td>
				</tr>
				<tr>
					
                    <td colspan="3"><table border="1" width="800" id="table16" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
                        <tr>
                          <td width="95" align="center" bgcolor="#F7E6B7">&nbsp;</td>
						  <td width="95" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Location</font></td>
						  <td width="95" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Longitude</font></td>
						  <td width="95" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Latitude</font></td>
						  <td width="118" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Total Capacity (kl)</font> </td>
                          <td width="221" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Status</font> </td>
                        </tr> 
						<?php
			$qr2="select * from tbl_dtls_q3_reserv2 where loc_id='$id1' and reserv_id LIKE 'CWR%' order by 0+replace(reserv_id,'CWR','')";
			$res2=mysql_query($qr2);
			while($row2=mysql_fetch_array($res2))
			{
			?>               
                        <tr align="center">
                          <td height="22"><label id="reserv_id"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_id]";?></font></label></td>
                          <td height="22"><label id="reserv_location"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_location]";?></font></label></td>
                          <td height="22"><label id="reserv_longitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_longitude]";?></font></label></td>
                          <td height="22"><label id="reserv_latitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_latitude]";?></font></label></td>
                          <td height="22"><label id="reserv_cap"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_cap]";?></font></label></td>
                          <td height="22"><label id="reserv_status"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_status]";?></font></label></td>
                        </tr>
						<?php } ?>
						<tr>
						<td height="2" colspan="6" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"></font></td>
						</tr>        
					  </table></td></tr>	
				<tr>
					<td width="33%">
						<font style="font-size: 8.5pt" face="Verdana" color="#990000">&nbsp;<span style="font-style: normal">Ground Level Service Reservoir (GLSR)</span></font></td>
					<td width="46%" align="center"><label id="glsr_no"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row1[glsr_no]";?></font></label></td>
					<td width="21%" align="center"><label id="sc_st_glsr"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row1[sc_st_glsr]";?></font></label></td>
				</tr>
				<tr>
					
                    <td colspan="3"><table border="1" width="800" id="table16" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
                        <tr>
                          <td width="95" align="center" bgcolor="#F7E6B7">&nbsp;</td>
						  <td width="95" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Location</font></td>
						  <td width="95" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Longitute</font></td>
						  <td width="95" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Lattitude</font></td>
						  <td width="118" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Total Capacity (kl)</font> </td>
                          <td width="221" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Status</font> </td>
                        </tr> 
						<?php
			$qr2="select * from tbl_dtls_q3_reserv2 where loc_id='$id1' and reserv_id LIKE 'GLSR%' order by 0+replace(reserv_id,'GLSR','')";
			$res2=mysql_query($qr2);
			while($row2=mysql_fetch_array($res2))
			{
			?>                              
                        <tr>
                          <td height="22"><label id="reserv_id"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_id]";?></font></label></td>
                          <td height="22"><label id="reserv_location"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_location]";?></font></label></td>
                          <td height="22"><label id="reserv_longitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_longitude]";?></font></label></td>
                          <td height="22"><label id="reserv_latitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_latitude]";?></font></label></td>
                          <td height="22"><label id="reserv_cap"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_cap]";?></font></label></td>
                          <td height="22"><label id="reserv_status"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_status]";?></font></label></td>
                        </tr>
						<?php } ?>
						<tr>
						<td height="2" colspan="6" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"></font></td>
						</tr>
					  </table></td></tr>
				<tr>
					<td width="33%" height="26">
						<font style="font-size: 8.5pt" face="Verdana" color="#990000">&nbsp;Ground 
						level Reservoir (GLR)</font></td>
					<td width="46%" align="center"><label id="glr_no"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row1[glr_no]";?></font></label></td>
					<td width="21%" align="center"><label id="sc_st_glr"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row1[sc_st_glr]";?></font></label></td>
				</tr>
				<tr>
                    <td colspan="3"><table border="1" width="800" id="table16" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
                        <tr>
                          <td width="95" align="center" bgcolor="#F7E6B7">&nbsp;</td>
						  <td width="95" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Location</font></td>
						  <td width="95" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Longitude</font></td>
						  <td width="95" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Latitude</font></td>
						  <td width="118" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Total Capacity (kl)</font> </td>
                          <td width="221" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Status</font> </td>
                        </tr> 
						<?php
			$qr2="select * from tbl_dtls_q3_reserv2 where loc_id='$id1' and reserv_id LIKE 'GLR%' order by 0+replace(reserv_id,'GLR','')";
			$res2=mysql_query($qr2);
			while($row2=mysql_fetch_array($res2))
			{
			?>                              
                        <tr>
                          <td height="22"><label id="reserv_id"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_id]";?></font></label></td>
                          <td height="22"><label id="reserv_location"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_location]";?></font></label></td>
                          <td height="22"><label id="reserv_longitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_longitude]";?></font></label></td>
                          <td height="22"><label id="reserv_latitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_latitude]";?></font></label></td>
                          <td height="22"><label id="reserv_cap"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_cap]";?></font></label></td>
                          <td height="22"><label id="reserv_status"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_status]";?></font></label></td>
                        </tr>
						<?php }?>
						<tr>
						<td height="2" colspan="6" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"></font></td>
						</tr>
					  </table></td></tr>
				<tr>
					<td width="33%">
						<font style="font-size: 8.5pt" face="Verdana" color="#990000">&nbsp;Over 
						Head Service Reservoir (OHSR)</font></td>
				  	<td width="46%" align="center"><label id="ohsr_no"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row1[ohsr_no]";?></font></label></td>
					<td width="21%" align="center"><label id="sc_st_ohsr"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row1[sc_st_ohsr]";?></font></label></td>
				</tr>
				<tr>
                    <td colspan="3"><table border="1" width="800" id="table16" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
                        <tr>
                          <td width="95" align="center" bgcolor="#F7E6B7">&nbsp;</td>
						  <td width="95" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Location</font></td>
						  <td width="95" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Longitute</font></td>
						  <td width="95" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Latitude</font></td>
						  <td width="118" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Total Capacity (kl)</font> </td>
                          <td width="221" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Status</font> </td>
                        </tr> 
						<?php
			$qr2="select * from tbl_dtls_q3_reserv2 where loc_id='$id1' and reserv_id LIKE 'OHSR%' order by 0+replace(reserv_id,'OHSR','')";
			$res2=mysql_query($qr2);
			while($row2=mysql_fetch_array($res2))
			{
			?>                              
                        <tr>
                          <td height="22"><label id="reserv_id"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_id]";?></font></label></td>
                          <td height="22"><label id="reserv_location"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_location]";?></font></label></td>
                          <td height="22"><label id="reserv_longitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_longitude]";?></font></label></td>
                          <td height="22"><label id="reserv_latitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_latitude]";?></font></label></td>
                          <td height="22"><label id="reserv_cap"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_cap]";?></font></label></td>
                          <td height="22"><label id="reserv_status"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[reserv_status]";?></font></label></td>
                        </tr>
						<?php }?>
						<tr>
						<td height="2" colspan="6" align="center" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"></font></td>
						</tr>
					  </table></td></tr>
			</table></td></tr>
		<tr>
			<td>&nbsp;</td>
		</tr>
		<tr>
			<td bgcolor="#EEEEEE" height="20"><font color="#000000">&nbsp;</font>
				<span style="font-weight: 700"><font face="Arial" style="font-size: 8.5pt" color=																						                "#000000">Public Stand Post (PSP) </font></span>
			</td>
		</tr>
				<tr>
					<td>
						<table border="1" width="100%" id="table12" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
								<tr>
									<td width="32%" align="center" bgcolor="#F7E6B7" colspan="2">
										<font style="font-size: 8.5pt" face="Verdana" color="#990000">
										No. of PSPs</font></td>
								</tr>
								<tr>
									<td width="32%" align="center" bgcolor="#F7E6B7">
										<font style="font-size: 8.5pt" face="Verdana" color="#990000">
										Total</font></td>
									<td width="32%" align="center" bgcolor="#F7E6B7">
										<font style="font-size: 8.5pt" face="Verdana" color="#990000">
										In SC / ST Bastis</font></td>
								</tr>
								<tr>
									<td width="13%" align="center"><label id="psp_total"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row1[psp_total]";?></font></label>                                    </td>
									<td width="13%" align="center"><label id="psp_sc_st"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row1[psp_sc_st]";?></font></label>                                    </td>
								</tr>
								<tr>
									<td colspan="2"><table border="1" width="800" id="table11" cellpadding="0" bgcolor="#FDF9EE" style="border-collapse:collapse; border-color:#99CCCC;">
									<tr>
									<td height="27" align="center" width="10%" bgcolor="#F7E6B7">
									<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Taps/PSP Nos.</font></td>
									<td height="27" align="center" width="9%" bgcolor="#F7E6B7"><font face="Verdana" style="font-size: 8.5pt" color="#990000">Location</font></td>
									<td width="10%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Longitude</font></td>
    								<td width="11%" bgcolor="#F7E6B7" align="center"><font style="font-size: 8.5pt" face="Verdana" color="#990000">Latitude</font></td>
									<td height="27" align="center" width="17%" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Attached with(GLR)</font></td>
									<td height="27" align="center" width="20%" bgcolor="#F7E6B7"><font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Attached with CWT(Cattle water trough)</font></td>
		    						<td align="center" width="23%" bgcolor="#F7E6B7"><font face="Verdana" style="font-size: 8.5pt" color="#990000">In SC/ST Basti</font></td>
								</tr>
		<?php
			$qr2="select * from tbl_dtls_q3_psp where loc_id='$id1'";
			$res2=mysql_query($qr2);
			while($row2=mysql_fetch_array($res2))
			{
			?>           	
		<tr>
			<td width="10%" align="center"><label id="psp_taps "><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[psp_taps]";?></font></label></td>
			<td width="9%" align="center"><label id="psp_loc"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[psp_loc]";?></font></label></td>
		  	<td width="10%" align="center"><label id="psp_longitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[psp_longitude]";?></font></label></td>
    		<td width="11%" align="center"><label id="psp_latitude"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[psp_latitude]";?></font></label></td>
			<td width="17%" align="center"><label id="psp_glr"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[psp_glr]";?></font></label></td>
			<td align="center"><label id="psp_cwt"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[psp_cwt]";?></font></label></td>
		    <td align="center"><label id="sc_st"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row2[sc_st]";?></font></label></td>
		</tr>
		<?php
		} 
		?>
		</table></td></tr>
</table></td></tr>		
			<tr><td>&nbsp;</td></tr>
			<tr><td>&nbsp;</td></tr>
			<tr><td>&nbsp;</td></tr>
	<tr>
		<td align="center">
		<input type="submit" value="Back" name="back" style="font-size: 8pt;font-family:Verdana; border-style: solid; border-width: 1px">&nbsp;&nbsp;
			<input type="submit" value="Next" name="submit" style="font-size: 8pt; font-family: Verdana; border-style: solid; border-width: 1px">
		</td>
	</tr>
</table>
</form>
</div>
</body>
</html>